import openpyxl
# workbook=openpyxl.Workbook('user_info.xlsx')
# workbook.create_sheet('one')
# workbook.create_sheet('two',0)
# workbook.save('user_info.xlsx')
# workbook=openpyxl.load_workbook('user_info.xlsx')
# workbook.remove(workbook['two'])
# workbook.save('user_info.xlsx')

# workbook=openpyxl.load_workbook('user_info.xlsx')
# worksheet=workbook['one']
# worksheet['A1']='hello'
# worksheet['A2']='world'
# workbook.save('user_info.xlsx')
# workbook=openpyxl.load_workbook('user_info.xlsx')
# worksheet=workbook.create_sheet('three')
# data=[
#     ['name','age','sex'],
#     ['张三','18','男'],
#     ['李四','19','女'],
#     ['王五','20','男'],
#     ['赵六','21','女'],
#     ['钱七','22','男'],
#     ['孙八','23','女'],
#     ['周九','24','男'],
#     ['吴十','25','女'],
#     ['郑十一','26','男'],
#     ['王十二','27','女'],
#     ['李十三','28','男'],
#     ['赵十四','29','女'],
# ]
# for i in data:
#     worksheet.append(i)
# # workbook.save('user_info.xlsx')
# workbook=openpyxl.load_workbook('user_info.xlsx')
# worksheet=workbook.create_sheet('four')
# for i in range(1,21):
#     worksheet.append(range(1,21))
# workbook.save('user_info.xlsx')
workbook=openpyxl.load_workbook('user_info.xlsx')
worksheet=workbook['four']
print(worksheet['A1'].value)